.. _`Replace values in Table`:

.. _`org.sysess.sympathy.data.table.tablevaluesearchreplace`:

Replace values in Table
~~~~~~~~~~~~~~~~~~~~~~~

.. image:: search_replace.svg
   :width: 48


Search and replace values in Table.



**Documentation**

Search and replace string and unicode values in Table.


**Definition**


*Input ports*

    :table:  table

        Input Table


*Output ports*

    :table:  table

        Table with replaced values



*Configuration*:
    **Select columns** (columns)
        Select the columns to use perform replace on
    **Default value** (default)
        Specify default value
    **Search** (find)
        Specify search expression.
    **Ignore case** (ignore_case)
        Ignore case when searching
    **Text replace only (using regex)** (literal)
        Perform regex replacements in string columns, i.e., columns with types text and bytes, other columns are ignored. Disable this option to replace full values, without using regex across all types of columns.
    **Replace** (replace)
        Specify replace expression.
    **Use default** (use_default)
        Use default value when not found.

.. automodule:: node_table_value_search_replace
    :noindex:

.. class:: TableValueSearchReplace
    :noindex:






**Example flows**

* :download:`ReplaceValuesInTable.syx </_examples/Sympathy/Data Processing/Data/ReplaceValuesInTable.syx>`